Database reference guide

HOME

Cerberus [USER] options

This section provides an alphabetical listing of the valid [USER] options.

Each active user of the system has a [USER_USERNAME] section in the cerberus.ini file. This controls the display settings for the user.

Note: Changing the user settings does not affect the SYSTEM settings which control the internal storage formats.
DateFormat Description Controls the display of DATE fields for the user.
Part

DateFormat = [VALUE]

  • 0 : CCYYMMDD
  • 1 : DDMMCCYY
  • 2 : CCYYDDMM
  • 3 : MMDDCCYY
  • 4 : DDMMYY
  • 5 : MMDDYY
  • 6 : DDMMMCCYY
Default If not set, the SystemDateFormat will be used.
Remarks

This does not affect how DATE fields are stored. The storage format of DATE fields is controlled by the SystemDateFormat setting.

TimeFormat Description Controls the display of TIME fields for the user.
Part

TimeFormat = [VALUE]

  • 0 : HHMMSS
  • 1 : HHMM
  • 2 : HH:MM:SS
  • 3 : HH:MM
Default If not set, the SystemTimeFormat will be used.
Remarks

This does not affect how TIME fields are stored. The storage format of DATE fields is controlled by the SystemTimeFormat setting.

DateTimeFormat Description Controls the display of DATETIME fields for the user.
Part

DateTimeFormat = [VALUE]

  • 00 : CCYYMMDD HHMMSS
  • 01 : CCYYMMDD HHMM
  • 02 : CCYYMMDD HH:MM:SS
  • 03 : CCYYMMDD HH:MM
  • 04 : DDMMCCYY HHMMSS
  • 05 : DDMMCCYY HHMM
  • 06 : DDMMCCYY HH:MM:SS
  • 07 : DDMMCCYY HH:MM
  • 08 : CCYYDDMM HHMMSS
  • 09 : CCYYDDMM HHMM
  • 10 : CCYYDDMM HH:MM:SS
  • 11 : CCYYDDMM HH:MM
  • 12 : MMDDCCYY HHMMSS
  • 13 : MMDDCCYY HHMM
  • 14 : MMDDCCYY HH:MM:SS
  • 15 : MMDDCCYY HH:MM
  • 16 : DDMMYY HHMMSS
  • 17 : DDMMYY HHMM
  • 18 : DDMMYY HH:MM:SS
  • 19 : DDMMYY HH:MM
  • 20 : MMDDYY HHMMSS
  • 21 : MMDDYY HHMM
  • 22 : MMDDYY HH:MM:SS
  • 23 : MMDDYY HH:MM
  • 24 : DDMMMCCYY HHMMSS
  • 25 : DDMMMCCYY HHMM
  • 26 : DDMMMCCYY HH:MM:SS
  • 27 : DDMMMCCYY HH:MM
Default If not set, the SystemDateTimeFormat will be used.
Remarks

This does not affect how DATETIME fields are stored. The storage format of DATETIME fields is controlled by the SystemDateTimeFormat setting.

  Online & Instructor-Led Courses | Training Videos | Webinar Recordings
© Alterian. All Rights Reserved. | Privacy Policy | Legal Notice